<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../Connections/test.jsp" %>
<%
    Driver DriverRecordset1 = (Driver) Class.forName(MM_test_DRIVER).newInstance();
    Connection ConnRecordset1 = DriverManager.getConnection(MM_test_STRING, MM_test_USERNAME, MM_test_PASSWORD);
    PreparedStatement StatementRecordset1 = ConnRecordset1.prepareStatement("SELECT *  FROM shengwuyixue.course  WHERE shengwuyixue.course.type='bixiu' and shengwuyixue.course.kind='yan'");
    ResultSet Recordset1 = StatementRecordset1.executeQuery();
    boolean Recordset1_isEmpty = !Recordset1.next();
    boolean Recordset1_hasData = !Recordset1_isEmpty;
    Object Recordset1_data;
    int Recordset1_numRows = 0;
%>
<%
    Driver DriverRecordset2 = (Driver) Class.forName(MM_test_DRIVER).newInstance();
    Connection ConnRecordset2 = DriverManager.getConnection(MM_test_STRING, MM_test_USERNAME, MM_test_PASSWORD);
    PreparedStatement StatementRecordset2 = ConnRecordset2.prepareStatement("SELECT *  FROM shengwuyixue.course  WHERE shengwuyixue.course.type='xianxuan' and shengwuyixue.course.kind='yan'");
    ResultSet Recordset2 = StatementRecordset2.executeQuery();
    boolean Recordset2_isEmpty = !Recordset2.next();
    boolean Recordset2_hasData = !Recordset2_isEmpty;
    Object Recordset2_data;
    int Recordset2_numRows = 0;
%>
<%
    Driver DriverRecordset3 = (Driver) Class.forName(MM_test_DRIVER).newInstance();
    Connection ConnRecordset3 = DriverManager.getConnection(MM_test_STRING, MM_test_USERNAME, MM_test_PASSWORD);
    PreparedStatement StatementRecordset3 = ConnRecordset3.prepareStatement("SELECT *  FROM shengwuyixue.course  WHERE shengwuyixue.course.type='renxuan' and shengwuyixue.course.kind='yan'");
    ResultSet Recordset3 = StatementRecordset3.executeQuery();
    boolean Recordset3_isEmpty = !Recordset3.next();
    boolean Recordset3_hasData = !Recordset3_isEmpty;
    Object Recordset3_data;
    int Recordset3_numRows = 0;
%>
<%
    int Repeat1__numRows = -1;
    int Repeat1__index = 0;
    Recordset1_numRows += Repeat1__numRows;
%>
<%
    int Repeat2__numRows = -1;
    int Repeat2__index = 0;
    Recordset2_numRows += Repeat2__numRows;
%>
<%
    int Repeat3__numRows = -1;
    int Repeat3__index = 0;
    Recordset3_numRows += Repeat3__numRows;
%>
<% String MM_paramName = ""; %>
<%
    // *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters

    String MM_keepBoth, MM_keepURL = "", MM_keepForm = "", MM_keepNone = "";
    String[] MM_removeList = {"index", MM_paramName};

// create the MM_keepURL string
    if (request.getQueryString() != null) {
        MM_keepURL = '&' + request.getQueryString();
        for (int i = 0; i < MM_removeList.length && MM_removeList[i].length() != 0; i++) {
            int start = MM_keepURL.indexOf(MM_removeList[i]) - 1;
            if (start >= 0 && MM_keepURL.charAt(start) == '&' &&
                    MM_keepURL.charAt(start + MM_removeList[i].length() + 1) == '=') {
                int stop = MM_keepURL.indexOf('&', start + 1);
                if (stop == -1) stop = MM_keepURL.length();
                MM_keepURL = MM_keepURL.substring(0, start) + MM_keepURL.substring(stop);
            }
        }
    }

// add the Form variables to the MM_keepForm string
    if (request.getParameterNames().hasMoreElements()) {
        java.util.Enumeration items = request.getParameterNames();
        while (items.hasMoreElements()) {
            String nextItem = (String) items.nextElement();
            boolean found = false;
            for (int i = 0; !found && i < MM_removeList.length; i++) {
                if (MM_removeList[i].equals(nextItem)) found = true;
            }
            if (!found && MM_keepURL.indexOf('&' + nextItem + '=') == -1) {
                MM_keepForm = MM_keepForm + '&' + nextItem + '=' + java.net.URLEncoder.encode(request.getParameter(nextItem));
            }
        }
    }

    String tempStr = "";
    for (int i = 0; i < MM_keepURL.length(); i++) {
        if (MM_keepURL.charAt(i) == '<') tempStr = tempStr + "&lt;";
        else if (MM_keepURL.charAt(i) == '>') tempStr = tempStr + "&gt;";
        else if (MM_keepURL.charAt(i) == '"') tempStr = tempStr + "&quot;";
        else tempStr = tempStr + MM_keepURL.charAt(i);
    }
    MM_keepURL = tempStr;

    tempStr = "";
    for (int i = 0; i < MM_keepForm.length(); i++) {
        if (MM_keepForm.charAt(i) == '<') tempStr = tempStr + "&lt;";
        else if (MM_keepForm.charAt(i) == '>') tempStr = tempStr + "&gt;";
        else if (MM_keepForm.charAt(i) == '"') tempStr = tempStr + "&quot;";
        else tempStr = tempStr + MM_keepForm.charAt(i);
    }
    MM_keepForm = tempStr;

// create the Form + URL string and remove the intial '&' from each of the strings
    MM_keepBoth = MM_keepURL + MM_keepForm;
    if (MM_keepBoth.length() > 0) MM_keepBoth = MM_keepBoth.substring(1);
    if (MM_keepURL.length() > 0) MM_keepURL = MM_keepURL.substring(1);
    if (MM_keepForm.length() > 0) MM_keepForm = MM_keepForm.substring(1);
%>

<%
    Class.forName(MM_test_DRIVER);
    Connection conn = DriverManager.getConnection(MM_test_STRING, MM_test_USERNAME, MM_test_PASSWORD);
    PreparedStatement pstmt = conn.prepareStatement("select content from document where document_type_id = '7' and status = '1' limit 1");
    ResultSet rs = pstmt.executeQuery();
    String content = null;
    if(rs.next()){
        content = rs.getString("content");
    }

    //读文件


%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title>北京交通大学计算机与信息技术学院生物医学工程系</title>
    <link href="<%=request.getContextPath()%>/include/css/css.css" rel="stylesheet" type="text/css"/>
    <style type="text/css">
        <!--
        .STYLE1 {
            font-size: 16px;
            font-weight: bold;
        }

        .STYLE3 {
            font-size: 18px;
            font-weight: bold;
        }

        .STYLE5 {
            font-size: 16px
        }

        .STYLE7 {
            font-size: 16px;
            color: #000000;
            font-weight: bold;
        }

        .STYLE8 {
            color: #000000;
            font-size: 16px;
        }

        .STYLE9 {
            font-size: 12px
        }

        .STYLE10 {
            color: #FFFFFF
        }

        .STYLE12 {
            font-size: 16
        }

        -->
    </style>
</head>
<body>
<div class="zhong">
    <jsp:include page="/include/banner.jsp"/>
    <jsp:include page="/include/menu.jsp"/>

    <div class="main">
        <div class="left">
            <div class="box_1">
                <div class="left_title STYLE1">课程一览</div>
                <div class="left_news">
                    <ul>
                        <li><a href="index.jsp" class="hover">本科生培养</a></li>
                        <li><a href="master.jsp">研究生培养</a></li>
                        <li><a href="course.jsp">本科生课程表</a></li>
                        <li><a href="master_course.jsp">研究生课程表</a></li>

                    </ul>
                </div>
            </div>
            <!--

           <div class="box_1">
               <div class="left_title STYLE1">合作交流</div>
               <div class="left_nr">
                 <ul>
                   <li><a href="">项目合作交流</a></li>
                   <li><a href="">教学合作交流</a></li>
             <li><a href="">公司企业交流</a></li>
                   <li><a href="">国内合作交流</a></li>
                   <li><a href="">国外合作交流</a></li>

                 </ul>
               </div>
             </div>
             <div class="box_1" style="margin:0px;">
               <div class="left_title STYLE1">信息服务</div>
               <div class="left_nr">
                 <ul>
                   <li><a href="#">资源下载</a></li>
              <li><a href="#">资源上传</a></li>
               <li><a href="#">注册登录</a></li>
                <li><a href="#">后台管理</a></li>


                 </ul>
               </div>
             </div>

           -->

        </div>
        <div class="right">
            <div class="right_title STYLE5">
                <p>本科生课程一览</p>
                <p>&nbsp;</p>
                <hr/>
                <p>&nbsp;</p>
            </div>
            <p>&nbsp;</p>
            <div id="content">
                <p><%=content%></p>
            </div>
            <%--<table width="100%" border="1" cellspacing="0" bgcolor="#FFFFFF">--%>
            <%--<tr>--%>
            <%--<td>--%>
            <%--<div align="center">课程名称</div>--%>
            <%--</td>--%>
            <%--<td>--%>
            <%--<div align="center">授课教师</div>--%>
            <%--</td>--%>
            <%--<td>--%>
            <%--<div align="center">课程类别</div>--%>
            <%--</td>--%>
            <%--</tr>--%>
            <%--<tr>--%>
            <%--<td colspan="3">--%>
            <%--<div align="center" class="STYLE7">必修课</div>--%>
            <%--</td>--%>
            <%--</tr>--%>
            <%--<% while ((Recordset1_hasData) && (Repeat1__numRows-- != 0)) { %>--%>
            <%--<tr>--%>
            <%--<td>--%>
            <%--<div align="center"><A--%>
            <%--HREF="master_bixiu_courseDetail.jsp?<%= MM_keepNone + ((MM_keepNone!="")?"&":"") + "courseID=" + (((Recordset1_data = Recordset1.getObject("courseID"))==null || Recordset1.wasNull())?"":Recordset1_data) %>"><%=(((Recordset1_data = Recordset1.getObject("courseName")) == null || Recordset1.wasNull()) ? "" : Recordset1_data)%>--%>
            <%--</A></div>--%>
            <%--</td>--%>
            <%--<td>--%>
            <%--<div--%>
            <%--align="center"><%=(((Recordset1_data = Recordset1.getObject("teacher")) == null || Recordset1.wasNull()) ? "" : Recordset1_data)%>--%>
            <%--</div>--%>
            <%--</td>--%>
            <%--<td>--%>
            <%--<div align="center">专业必修</div>--%>
            <%--</td>--%>
            <%--</tr>--%>
            <%--<%--%>
            <%--Repeat1__index++;--%>
            <%--Recordset1_hasData = Recordset1.next();--%>
            <%--}--%>
            <%--%>--%>
            <%--<tr>--%>
            <%--<td colspan="3" class="STYLE8">--%>
            <%--<div align="center"><strong>选修课</strong></div>--%>
            <%--</td>--%>
            <%--</tr>--%>
            <%--<% while ((Recordset2_hasData) && (Repeat2__numRows-- != 0)) { %>--%>
            <%--<tr>--%>
            <%--<td>--%>
            <%--<div align="center"><A--%>
            <%--HREF="master_xianxuan_courseDetail.jsp?<%= MM_keepNone + ((MM_keepNone!="")?"&":"") + "courseID=" + (((Recordset2_data = Recordset2.getObject("courseID"))==null || Recordset2.wasNull())?"":Recordset2_data) %>"><%=(((Recordset2_data = Recordset2.getObject("courseName")) == null || Recordset2.wasNull()) ? "" : Recordset2_data)%>--%>
            <%--</A></div>--%>
            <%--</td>--%>
            <%--<td>--%>
            <%--<div--%>
            <%--align="center"><%=(((Recordset2_data = Recordset2.getObject("teacher")) == null || Recordset2.wasNull()) ? "" : Recordset2_data)%>--%>
            <%--</div>--%>
            <%--</td>--%>
            <%--<td>--%>
            <%--<div align="center">专业选修</div>--%>
            <%--</td>--%>
            <%--</tr>--%>
            <%--<%--%>
            <%--Repeat2__index++;--%>
            <%--Recordset2_hasData = Recordset2.next();--%>
            <%--}--%>
            <%--%>--%>
            <%--<tr>--%>
            <%--<td colspan="3">--%>
            <%--<div align="center"><span class="STYLE7">任选课</span></div>--%>
            <%--</td>--%>
            <%--</tr>--%>
            <%--<% while ((Recordset3_hasData) && (Repeat3__numRows-- != 0)) { %>--%>
            <%--<tr>--%>
            <%--<td height="17">--%>
            <%--<div align="center"><A--%>
            <%--HREF="master_renxuan_courseDetail.jsp?<%= MM_keepNone + ((MM_keepNone!="")?"&":"") + "courseID=" + (((Recordset3_data = Recordset3.getObject("courseID"))==null || Recordset3.wasNull())?"":Recordset3_data) %>"><%=(((Recordset3_data = Recordset3.getObject("courseName")) == null || Recordset3.wasNull()) ? "" : Recordset3_data)%>--%>
            <%--</A></div>--%>
            <%--</td>--%>
            <%--<td>--%>
            <%--<div--%>
            <%--align="center"><%=(((Recordset3_data = Recordset3.getObject("teacher")) == null || Recordset3.wasNull()) ? "" : Recordset3_data)%>--%>
            <%--</div>--%>
            <%--</td>--%>
            <%--<td>--%>
            <%--<div align="center">专业任选</div>--%>
            <%--</td>--%>
            <%--</tr>--%>
            <%--<%--%>
            <%--Repeat3__index++;--%>
            <%--Recordset3_hasData = Recordset3.next();--%>
            <%--}--%>
            <%--%>--%>
            <%--</table>--%>
            <p>&nbsp;</p>
        </div>
        <!--这里是链接模块,已删除，可自行添加-->
        <div class="clear"></div>
        <div class="clear"></div>
    </div>


    <div class="clear"></div>
</div>
<div class="bottom">
    <p>地址：北京市海淀区上园村3号北京交通大学信息中心　邮编：100044　 </p>
    <p>北京交通大学计算机与信息技术学院生物医学工程系保留网站所有权利</p>
    <p> 未经允许不得复制、镜像</p>
    <p>京公网安备：110402430059 号</p>
    <br/>
    版权所有&copy;ouchanghai,cit.bjtu.
</div>
</div>
<script src="<%=request.getContextPath()%>/include/js/meun.js" type="text/javascript"></script>
<script src="../include/css/jquery.js" type="text/javascript"></script>
<script type="text/javascript" language="JavaScript">
    $(function(){

        var content = $("#content > div").first();
        content.css({"width": "", "margin-top": "0","margin-left":"0","margin-right":"0" });
        var table = $("#content > div > table").first();
        table.css({"width": "", "margin-top": "0","margin-left":"0","margin-right":"0" });
    });
</script>
</body>
</html>
<%
    Recordset1.close();
    StatementRecordset1.close();
    ConnRecordset1.close();
%>
<%
    Recordset2.close();
    StatementRecordset2.close();
    ConnRecordset2.close();
%>
<%
    Recordset3.close();
    StatementRecordset3.close();
    ConnRecordset3.close();
%>
